package com.computer.subscribe.mapper;

import com.computer.subscribe.pojo.TUser;
import com.computer.subscribe.pojo.TUserExample;
import java.util.List;
import org.apache.ibatis.annotations.Param;

public interface TUserMapper {

	/**
	 * 根据指定的学号/工号列值,统计计算符合条件的ID数量
	 * 
	 * @param value
	 * @return
	 */
	Integer selectCountIdByUserNumValue(@Param("value") Long value);

	/**
	 * 根据指定的角色类型列值,统计计算符合条件的ID数量
	 * 
	 * @param value
	 * @return
	 */
	Integer selectCountIdByRoleValue(@Param("value") Integer value);

	/**
	 * 根据指定的邮箱列值,统计计算符合条件的ID数量
	 * 
	 * @param value
	 * @return
	 */
	Integer selectCountIdByMailBoxValue(@Param("value") String value);

	/**
	 * 根据指定的电话列值,统计计算符合条件的ID数量
	 * 
	 * @param value
	 * @return
	 */
	Integer selectCountIdByPhoneValue(@Param("value") String value);

	/**
	 * select count(id) from t_user;
	 * 
	 * @return
	 */
	int selectCountId();

	/**
	 * This method was generated by MyBatis Generator. This method corresponds to
	 * the database table t_user
	 *
	 * @mbggenerated Thu Apr 08 23:43:19 CST 2021
	 */
	int countByExample(TUserExample example);

	/**
	 * This method was generated by MyBatis Generator. This method corresponds to
	 * the database table t_user
	 *
	 * @mbggenerated Thu Apr 08 23:43:19 CST 2021
	 */
	int deleteByExample(TUserExample example);

	/**
	 * This method was generated by MyBatis Generator. This method corresponds to
	 * the database table t_user
	 *
	 * @mbggenerated Thu Apr 08 23:43:19 CST 2021
	 */
	int deleteByPrimaryKey(Integer id);

	/**
	 * This method was generated by MyBatis Generator. This method corresponds to
	 * the database table t_user
	 *
	 * @mbggenerated Thu Apr 08 23:43:19 CST 2021
	 */
	int insert(TUser record);

	/**
	 * This method was generated by MyBatis Generator. This method corresponds to
	 * the database table t_user
	 *
	 * @mbggenerated Thu Apr 08 23:43:19 CST 2021
	 */
	int insertSelective(TUser record);

	/**
	 * This method was generated by MyBatis Generator. This method corresponds to
	 * the database table t_user
	 *
	 * @mbggenerated Thu Apr 08 23:43:19 CST 2021
	 */
	List<TUser> selectByExample(TUserExample example);

	/**
	 * This method was generated by MyBatis Generator. This method corresponds to
	 * the database table t_user
	 *
	 * @mbggenerated Thu Apr 08 23:43:19 CST 2021
	 */
	TUser selectByPrimaryKey(Integer id);

	/**
	 * This method was generated by MyBatis Generator. This method corresponds to
	 * the database table t_user
	 *
	 * @mbggenerated Thu Apr 08 23:43:19 CST 2021
	 */
	int updateByExampleSelective(@Param("record") TUser record,
			@Param("example") TUserExample example);

	/**
	 * This method was generated by MyBatis Generator. This method corresponds to
	 * the database table t_user
	 *
	 * @mbggenerated Thu Apr 08 23:43:19 CST 2021
	 */
	int updateByExample(@Param("record") TUser record,
			@Param("example") TUserExample example);

	/**
	 * This method was generated by MyBatis Generator. This method corresponds to
	 * the database table t_user
	 *
	 * @mbggenerated Thu Apr 08 23:43:19 CST 2021
	 */
	int updateByPrimaryKeySelective(TUser record);

	/**
	 * This method was generated by MyBatis Generator. This method corresponds to
	 * the database table t_user
	 *
	 * @mbggenerated Thu Apr 08 23:43:19 CST 2021
	 */
	int updateByPrimaryKey(TUser record);
}